package com.csht.mapper;

import java.util.List;
import java.util.Map;

import com.csht.model.CshtCriminalRecords;

public interface CshtCriminalRecordsMapper {
	
	/**
	 * 根据用户id查询违规记录总数
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Integer getCriminalRecordsNumberByUserId(Integer userId) throws Exception;
	
	/**
	 * 根据用户id查询违规记录
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public List<CshtCriminalRecords> getCriminalRecordsByUserId(Map<String, Integer> res) throws Exception;
	
	/**
	 * 根据违规记录id查询
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public CshtCriminalRecords getCriminalRecordsById(Integer criminalRecordsId) throws Exception;
	
	/**
	 * 根据用户id查询非常严重违规次数
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Integer getLevelTimesByUserId(Integer userId) throws Exception;

}
